package com.vortex.cloud.sample.service;

import com.baomidou.mybatisplus.extension.service.IService;
import com.vortex.cloud.sample.domain.TaskUserInfo;
import com.vortex.cloud.sample.dto.ExcelMessageTaskUserInfoDTO;
import com.vortex.cloud.vfs.lite.base.dto.RestResultDTO;
import com.vortex.cloud.vfs.lite.base.dto.excel.ExcelMessageDTO;
import org.apache.poi.ss.formula.functions.T;
import org.springframework.data.domain.Sort;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;

/**
 * @author 王林
 * @version 1.0
 * @date 2021-10-15 周五
 * @time 13:58
 * @description
 */
public interface ExcelService extends IService<TaskUserInfo> {

    /**
     * @Description: 使用POI导入文件
     * @Param: [file]
     * @return: com.vortex.cloud.vfs.lite.base.dto.RestResultDTO<java.lang.String>
     * @Author: 王林
     * @Date: 2021/10/15
     */
    List<ExcelMessageDTO> importExcel(MultipartFile file, Integer startRowNum, Integer startCellNum);

    /**
     * @Description: 使用POI导出文件
     * @Param: [fileName, extension, downloadUrl, columnJson, list, response]
     * @return: com.vortex.cloud.vfs.lite.base.dto.RestResultDTO<com.vortex.cloud.vfs.lite.base.dto.excel.ExcelMessageDTO>
     * @Author: 王林
     * @Date: 2021/10/15
     */
//    RestResultDTO<String> exportExcel(Sort sort, String fileName, String extension, String downloadUrl, String columnJson, List<T> list, HttpServletResponse response);
}
